Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

1 Subject

4-2 Executive Summary

4-2 Executive Summary

Q Overview Descriptive statistics describes a data set. It is used to summarize and organize the data into something more manageable, actionable, and ready for presentation. It can also help organize data and present a business problem in an understandable manner. You can use descriptive statistics to understand and analyze the data for your organization. The employees in your company report struggling with burnout (being overworked). You have been asked to analyze the situation and recommend solutions to reduce employee burnout. You have access to an employee survey with employee responses related to the situation. This week you will analyze the employee survey data and create bar graphs to represent the data visually. Based on your analysis, you will then create an executive summary targeted to a non-technical audience unfamiliar with statistics. See the document Module Four Survey Response Key for the responses that were available on the survey. Prompt Part 1: Burnout Analysis: Bar Graphs To complete this assignment, you will use Tableau software that is located within the virtual desktop infrastructure (VDI). Follow the directions in the User Manual: Working With Tableau document to import these employee survey responses into Tableau and conduct a burnout analysis. Use Tableau to create bar graphs that will answer the following questions. Take screenshots of your bar graphs to include in your executive summary document. 1. Which gender is experiencing the burnout level “Pretty wiped out almost every day” most? 2. Which male age group is experiencing the stress level, “A little stress that would be expected with the ups and downs of life” at home the most? 3. Which leadership level strongly agrees with the fact that they love what they do? 4. Which gender with a tenure of 5+ years had the lowest number of responses for the burnout level “I feel great! Energy to spare!”? Part 2: Executive Summary Create an Executive Summary of your results addressing the following criteria: 1. Purpose and respondents: Explain the purpose of the executive summary and briefly describe the survey respondents. 2. Results: Summarize your bar graph analyses and answer the questions they represent. Add corresponding bar graphs to relevant sections of the summary to illustrate your analyses. 3. Recommendations: Based on your analysis, recommend two areas the company can focus on to reduce employee burnout. Guidelines for Submission To complete this assignment, you must submit the following: Executive Summary: Submit a 2- to 3-page Word document with 12-point Times New Roman font, double spacing, and one-inch margins. Include the screenshots of the graphs you generated in Tableau. Sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.

View Related Questions

Solution Preview

The purpose of the Executive Summary is to provide a brief summary of an analysis and help decision makers to take decisions on the basis of the analysis. It is an overview of a research report that integrates the key points for the person who is reading and help his or her to understand the overall content of the report. Survey Respondents The survey respondents are both male and female with different age group. For each questions they provided their answers. They answered multiple no. of questions.